USE JXC
GO
CREATE TABLE [dbo].[IndustryType]
    (
      [IndustryID] [int] NOT NULL
                         IDENTITY(1, 1) ,
      [ChinesName] [nvarchar](200) COLLATE Chinese_PRC_CI_AS
                                   NOT NULL ,
      [EnglishName] [nvarchar](200) COLLATE Chinese_PRC_CI_AS
                                    NULL
    )
ON  [PRIMARY]
GO
ALTER TABLE [dbo].[IndustryType] ADD CONSTRAINT [PK__Industry__808DEC2C6CA31EA0] PRIMARY KEY CLUSTERED  ([IndustryID]) ON [PRIMARY]
GO
 
